﻿<?xml version="1.0" encoding="utf-8" ?>
<AdoNetDataAccess connection="$ArticleDBConnection$" >
	<Sql>
		INSERT INTO eComOrderDeliveries
			(id, orderId, pickupDate,calculatedDate, trackingNumber, deliveryProviderId, deliveryMethodName, shippingTotal, handlingTotal)
		VALUES
			(@id, @orderId, @pickupDate, @calculatedDate, @trackingNumber, @deliveryProviderId, @deliveryMethodName, @shippingTotal, @handlingTotal)
	</Sql>
	<Param name="delivery.id" dbName="id" type="UniqueIdentifier"/>
	<Param name="order.id" dbName="orderId" type="UniqueIdentifier"/>
	<Param name="pickupDate" type="DateTime"/>
	<Param name="calculatedDate" type="DateTime" />
	<Param name="delivery.trackingNumber" dbName="trackingNumber" type="UnicodeVarChar"/>
	<Param name="delivery.provider.id" dbName="deliveryProviderId" type="UniqueIdentifier" />
	<Param name="delivery.deliveryMethodName" dbName="deliveryMethodName" type="String" />
	<Param name="delivery.shippingTotal" dbName="shippingTotal" type="Decimal" />
	<Param name="delivery.handlingTotal" dbName="handlingTotal" type="Decimal" />
</AdoNetDataAccess>